BibSonomy bookmarks for /tag/sql_2005%20Programowanie

SQL SERVER - 2005 - Sample Example of RANKING Functions - ROW_NUMBER, RANK, DENSE_RANK, NTILE « Journey to SQL Authority with Pinal Dave

tmodelsk — 2007-11-29T14:50:30+01:00

http://blog.sqlauthority.com/2007/10/09/sql-server-2005-sample-example-of-ranking-functions-row_number-rank-dense_rank-ntile/

Bazy danych K.Stencel

tmodelsk — 2007-11-29T14:50:30+01:00

Strona z materiałami dydaktycznymi z baz danych

Control of Flow with TSQL

tmodelsk — 2007-11-29T14:50:30+01:00

Don Schlichting explores the special Transact SQL Control of Flow key words used to direct the execution of statements.

DevX: Database Dev Zone

tmodelsk — 2007-11-29T14:50:30+01:00

Your starting point for database programming, including answers to frequently-asked technical questions about database development, Get Help with DB2 and SQL Server, feature articles, links to the best database development sites, and news about database tools and updates.

Functions (T-SQL)

tmodelsk — 2007-11-29T14:50:30+01:00

http://doc.ddart.net/mssql/sql70/fa-fz_15.htm

_123 TSQL functions

tmodelsk — 2007-11-29T14:50:30+01:00

This is a collection of 123 TSQL functions fo

Programmer's Corner - What is a SQL Server Temporary Table?

tmodelsk — 2007-11-29T14:50:30+01:00

http://www.programmers-corner.com/article/76

SQL Server 2005 Common Table Expressions

tmodelsk — 2007-11-29T14:50:30+01:00

http://www.simple-talk.com/sql/sql-server-2005/sql-server-2005-common-table-expressions/

Using the cursor Data Type in an OUTPUT Parameter

tmodelsk — 2007-11-29T14:50:30+01:00

Transact-SQL stored procedures can use the cursor data type only for OUTPUT parameters. If the cursor data type is specified for a parameter, both the VARYING and OUTPUT parameters are required. If the VARYING keyword is specified for a parameter, the data type must be cursor and the OUTPUT keyword must be specified.